[Doctrine-DBAL-DBALException]Unknown database type enum requested, Doctrine-DBAL-Platforms-MySqlPlatform may not support it.

[Doctrine\DBAL\DBALException]Unknown database type enum requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it. -

It is a known issue as stated in Laravel 5.1 documentation.

    Note: Renaming columns in a table with a enum column is not currently supported.

It happens when you have a enum column in your database table. Whether you are trying to rename another column, or change another column to nullable, this bug will appear. It's an issue with Doctrine\DBAL.

An easy fix for this is to just add this constructor method in your database migration file.

public function __construct()
{
    DB::getDoctrineSchemaManager()-&gt;getDatabasePlatform()-&gt;registerDoctrineTypeMapping('enum', 'string');
}

This will map all the ENUM columns to VARCHAR(), and the column will accept any string.

    This worked for me on Laravel 5.1 and Laravel 5.3. I hope this bug can be fixed soon.

Credit to @Gmatkowski's answer at https://stackoverflow.com/a/32860409/1193201

Comments

Submit

0 Comments

More Questions

php array has value	php string to int	php string replace
php string contains substring	php append to array	laravel run seed
php parse json	php check if string contains word	php split string
php artisan make migration	composer ignore requirements	in_array in php
Your requirements could not be resolved to an installable set of packages.	magento 2 composer install	laravel-ui v3.0.0 requires php ^7.3 - your php version (8.0.2) does not satisfy that requirement.
schema defaultstringlength(191)	laravel form validation	laravel table in model
use wordpress functions in external php file	composer ignore platform reqs	phpmailer send attachment
item count in cart quantitiy woocommerce	Laravel seed timestamps columns	php convert degrees to radians
php numbers from 1 to 100 array	php file read	php use variable as object key
php in array key	laravel controller code for editing a column in a table	htaccess post max size
laravel timestamps on pivot table	php array join	convert string to array laravel
wordpress get post by id	composer cache clean	laravel new project command
jetstream seed user with team	phpunit stop on failure	get record of last 24 hours in laravel
wordpress get fiture image	admin bar hide wordpress	laravel when
how to create shortcode	laravel decrement	check if all values in array are equal php
redirect previous page	how to allow cors through header in php	events.js:174 error discord.js

[Doctrine-DBAL-DBALException]Unknown database type enum requested, Doctrine-DBAL-Platforms-MySqlPlatform may not support it.

[Doctrine\DBAL\DBALException]Unknown database type enum requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it. -

Comments

0 Comments

More Questions

C

CSS

Objective-C

PHP

Java

C++

Javascript

Html

Python

SQL

Swift

Ruby

Go

R

TypeScript

Kotlin

Assembly

VBA

Scala

Rust

Elixir

Dart

Haskell

Perl

Fortran

Matlab

Scheme

Julia

Lua

Delphi

Pascal

Solidity

BASIC

ActionScript

Csharp